package com.oig.sys.base.dao;

import com.oig.sys.base.entity.TbBankNo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;

/**
@author wuxl
*/
public interface ITbBankNoDao extends JpaRepository<TbBankNo, Integer>, JpaSpecificationExecutor<TbBankNo> {

	TbBankNo getByBankNo(String bankNo);

	@Query("from TbBankNo b where b.bankNo in(:bankNoList)")
	List<TbBankNo> findByBankNoList(@Param("bankNoList") List<String> bankNoList);

}
